Editing chart completely & creating the 2 other charts 10



Editing the chart completely



 

 

1. Click the hierarchy button to set charts drilldown to Year.

 

2. Delete the day from under the date column then click the paint roller icon.

 

3. Background

 

1.   Click background and make transparency 100%.

 

4. Border

1.   Turn border on and choose the color.

2.   Click more colors and paste this hex code to get exact color #5BBEFF.

 

5.       Shadow

1.   Click Shadow and choose color #5BBEFF.

 

6.       Title

1.   Click title and type title name.

2.   Choose font color white.

3.   Choose Background color #0A5FB4.

 

7. Shapes

1.   Click shapes.

2.   Turn shade area on.

3.   Turn show marker on.

4.   Choose marker color #5BBEFF

 

 

8. Data Label 

1.   Turn on data label scroll down and turn on Customize series.

2.   Default will be Tornadoes Per Yr.

3.   Color white.

4.   Text size 10pt.

5.   Font family Segoe UI Bold.

6.   Background off.

7.   Click the drop down and choose the next name.

8.   Choose color #5BBEFF.

9.   Text Size 10pt.

10.        Font family Arial Black.

11.        Choose background color #0A5FB4

12.        Make the Transparency 0%.

13.        Go back to top of data labels and change display units to None

14.        Change position Outside end or leave on auto.

 

9.       Data Colors

1.   Click data colors.

2.   1st color should be #5BBEFF.

3.   Default Color #86BFBF.

 

 

10. Y axis

1.   Click Y axis.

2.   Color White

3.   Title off.

4.   Gridlines off

5.   Turn show secondary On.

6.   Scroll down and make color white.

 

11. X axis

1.   Click X axis

2.   Color white

3.   Type change to Categorical

4.   Minimum categorical width 30

5.   Maximum size 50%

6.   Inner padding 29%

7.   Turn title off

 

 

12.    Legend

1.   This should be on

2.   Color White

3.   Style choose Line and markers

 

 

 

 

CREATING THE 2 OTHER CHARTS

 

For Top Chart On The Right

 

1.   Click the chart already created and press on your keyboard ctrl+c to copy, then press ctrl+v to paste.

2.   Drag Over Date & Day of Week Name to the shared axis

3.   Drag Tornadoes per Yr to the column values.

4.   Drag YoY & CpT YoY to Line Values

5.   Click the hierarchy button and chart default should be quarters

6.   Click paint brush

 

X axis

1.   Minimum categorical width 30

2.   Maximum size 50%

3.   Inner padding 29%

 

Data Colors

1.   YoY color #F7893B

2.   CpT Color #D8BE75

3.   Default color #86BFBF

 

Data Labels

 

1.   Tornadoes Per Yr should be selected

2.   Color WHITE

3.   Text Size 10

4.   Backgorund Color BLACK

5.   Transparency 40%

6.   Scroll back up and choose YoY from drop down

7.   Color #F7893B

8.   Font family ARIAL BLACK

9.   Background color BLACK

10.        Transparency 67%

11.        Scroll back up and choose CpT YoY from drop down

12.        Color #D8BE75

13.        Text Size 10

14.        Background color #0A5FB4

15.        Transparency 14%

 

Shapes

1.   Line Style DASHED

2.   Marker Color #D8BE75

3.   Turn customize series on

4.   Choose YoY

5.   Line style DASHED

6.   Marker Size 5

7.   Marker Color #F7893B

 

 

For Bottom Chart

 

1.   Click the chart that was just created and press on your keyboard ctrl+c to copy, then press ctrl+v to paste.

2.   Drag Date only keep YEAR, Drag CATEGORY, Day of Week, and Date Quarter to the shared axis.

3.   Drag Cost per Tornado to the column values.

4.   Drag YoY & CpT YoY to Line Values

5.   Click the hierarchy button and chart default should be CATEGORY.

6.   Click paint brush

 

Data colors

 

1.   Default colors #5BBEFF


Formatting Tips & Tricks in Power BI - (2) Formatting Tips & Tricks in Power BI - YouTube